CREATE EXTERNAL TABLE jms_dm.dm_tab_departure_build_package_network_summary_dt
(
    scan_site_code    string comment '建包中心code',
    scan_site         string comment '建包中心name',
    site_agent_code   string comment '建包中心所属代理区code',
    site_agent_name   string comment '建包中心所属代理区name',
    pick_network_code string comment '取件网点code',
    pick_network_name string comment '取件网点name',
    date_time         string comment '扫描日期',
    buil_bag_num      int comment '建包票数'
)
    COMMENT '出港建包监控日报汇总'
    PARTITIONED BY (dt string COMMENT 't-1扫描时间')
    stored as parquet
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_departure_build_package_network_summary_dt'